qui insheet using "${hmrc_datadir}\CBT\governance indicators.csv",clear
qui drop countryname
qui rename est1 governance_est
qui save "${hmrc_datadir}\CBT\governance indicators",replace



preserve
merge 1:m alpha3code year using "${hmrc_datadir}\export_reg_final_ukmncs_fy_ntrans"
drop if _merge==1
drop _merge
save "${hmrc_datadir}\export_reg_final_ukmncs_fy_ntrans", replace
restore 

preserve
merge 1:m alpha3code year using "${hmrc_datadir}\export_reg_final_ukmncs_fy_apmonthly"
drop if _merge==1
drop _merge
save "${hmrc_datadir}\export_reg_final_ukmncs_fy_apmonthly", replace
restore


qui use "${hmrc_datadir}\CBT\governance indicators", clear

preserve
merge 1:m alpha3code year using "${hmrc_datadir}\export_reg_final_ukmncs_fy"
drop if _merge==1
drop _merge
save "${hmrc_datadir}\export_reg_final_ukmncs_fy",replace
restore

preserve
merge 1:m alpha3code year using "${hmrc_datadir}\export_reg_final_mncs_fy"
drop if _merge==1
drop _merge
save "${hmrc_datadir}\export_reg_final_mncs_fy",replace
restore
